package com.zhongwang.mms.module.material.dao;

import com.zhongwang.mms.module.material.model.*;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;
import java.util.List;

/**
 * @Description: 原料统计报表 数据访问层
 * @Author: China.wsg
 * @Date: 2020/06/09
 */
@Repository
public interface MReportFormsDao {

    /**
     * 项目剩余量
     *
     * @param residueModel 条件
     * @return list
     */
    List<MResidueModel> findResidueModel(MResidueModel residueModel);

    /**机械月出库总表*/
    List<MechanicsOutWar> findMatMechanicsOutWarList(MechanicsOutWar param);

    /**外厂月出库总表*/
    List<MechanicsOutWar> findmMatOutFactoryOutWarList(MechanicsOutWar param);

    /**原料中段消耗库存量查询*/
    List<CompositeOutcomeModel> findConsumedInventory(CompositeOutcomeModel compositeOutcomeModel);

    /**不常用库存查询*/
    List<MatInfrequentStockExport> findComplexStorage(ComplexStorageModel complexStorageModel);

    /**阶段报表*/
    List<MatStageReportModel> findMatStageReportList(MatStageReportModel param);

    /**项目在库里项目编号为150000的钢材总量*/
    BigDecimal selectSpecialSum();
}